
If Exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_MemberAddress') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_MemberAddress
END
GO
	CREATE VIEW V_MemberAddress
	AS 
	SELECT 
		Guid,NAME,Email,[Address],Postalcode,Tel,Mobile,IsDefault,
		MemLoginID,CreateUser,CreateTime,ModifyUser,ModifyTime,code
	FROM ShopNum1_Address
	WHERE IsDeleted=0
